Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 17925 |
| Missing cells | 86569 |
| Missing cells (%) | 18.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.6 MiB |
| Average record size in memory | 208.0 B |
Variable types
| Categorical | 12 |
|---|---|
| Numeric | 14 |
has_deposit is highly correlated with is_converted | High correlation |
mifid_money_other_brokers is highly correlated with mifid_invested_other_brokers | High correlation |
mifid_invested_other_brokers is highly correlated with mifid_money_other_brokers | High correlation |
is_converted is highly correlated with has_deposit | High correlation |
is_converted is highly correlated with has_deposit | High correlation |
has_deposit is highly correlated with is_converted | High correlation |
finish_mifid_days has 7513 (41.9%) missing values | Missing |
first_deposit_days has 12891 (71.9%) missing values | Missing |
linked_account_days has 17300 (96.5%) missing values | Missing |
demo_account_days has 15221 (84.9%) missing values | Missing |
demo_trade_days has 15787 (88.1%) missing values | Missing |
mock_account_days has 17848 (99.6%) missing values | Missing |
first_deposit_amount is highly skewed (γ1 = 27.49295343) | Skewed |
start_mifid_days has 12155 (67.8%) zeros | Zeros |
finish_mifid_days has 2219 (12.4%) zeros | Zeros |
first_deposit_days has 204 (1.1%) zeros | Zeros |
first_deposit_amount has 12891 (71.9%) zeros | Zeros |
first_deposit_platform has 1915 (10.7%) zeros | Zeros |
mifid_actual_savings has 1543 (8.6%) zeros | Zeros |
mifid_next_year_savings has 1543 (8.6%) zeros | Zeros |
mifid_invested_other_brokers has 8241 (46.0%) zeros | Zeros |
linked_account_days has 301 (1.7%) zeros | Zeros |
demo_account_days has 2056 (11.5%) zeros | Zeros |
demo_trade_days has 606 (3.4%) zeros | Zeros |
Reproduction
| Analysis started | 2021-05-31 14:08:45.586657 |
|---|---|
| Analysis finished | 2021-05-31 14:09:46.038749 |
| Duration | 1 minute and 0.45 seconds |
| Software version | pandas-profiling v2.13.0 |
| Download configuration | config.yaml |
user_currency
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| USD | |
|---|---|
| EUR | |
| GBP | 842 |
| NO_CURRENCY | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 3.001338912 |
| Min length | 3 |
Characters and Unicode
| Total characters | 53799 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EUR |
|---|---|
| 2nd row | USD |
| 3rd row | EUR |
| 4th row | USD |
| 5th row | USD |
| Value | Count | Frequency (%) |
| USD | 10675 | |
| EUR | 6405 | |
| GBP | 842 | 4.7% |
| NO_CURRENCY | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| usd | 10675 | |
| eur | 6405 | |
| gbp | 842 | 4.7% |
| no_currency | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 17083 | |
| S | 10675 | |
| D | 10675 | |
| R | 6411 | 11.9% |
| E | 6408 | 11.9% |
| G | 842 | 1.6% |
| B | 842 | 1.6% |
| P | 842 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (3) | 9 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 53796 | |
| Connector Punctuation | 3 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| U | 17083 | |
| S | 10675 | |
| D | 10675 | |
| R | 6411 | 11.9% |
| E | 6408 | 11.9% |
| G | 842 | 1.6% |
| B | 842 | 1.6% |
| P | 842 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (2) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| _ | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 53796 | |
| Common | 3 | < 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| U | 17083 | |
| S | 10675 | |
| D | 10675 | |
| R | 6411 | 11.9% |
| E | 6408 | 11.9% |
| G | 842 | 1.6% |
| B | 842 | 1.6% |
| P | 842 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (2) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| _ | 3 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 53799 |
Most frequent character per block
| Value | Count | Frequency (%) |
| U | 17083 | |
| S | 10675 | |
| D | 10675 | |
| R | 6411 | 11.9% |
| E | 6408 | 11.9% |
| G | 842 | 1.6% |
| B | 842 | 1.6% |
| P | 842 | 1.6% |
| N | 6 | < 0.1% |
| C | 6 | < 0.1% |
| Other values (3) | 9 | < 0.1% |
user_country
Real number (ℝ≥0)
| Distinct | 162 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66.30945607 |
| Minimum | 0 |
|---|---|
| Maximum | 161 |
| Zeros | 31 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 32 |
| median | 46 |
| Q3 | 100 |
| 95-th percentile | 160 |
| Maximum | 161 |
| Range | 161 |
| Interquartile range (IQR) | 68 |
Descriptive statistics
| Standard deviation | 44.52194711 |
|---|---|
| Coefficient of variation (CV) | 0.6714268182 |
| Kurtosis | -0.4134508841 |
| Mean | 66.30945607 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.8752028595 |
| Sum | 1188597 |
| Variance | 1982.203774 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46 | 4426 | |
| 31 | 1232 | 6.9% |
| 53 | 1101 | 6.1% |
| 160 | 1096 | 6.1% |
| 100 | 963 | 5.4% |
| 8 | 771 | 4.3% |
| 30 | 569 | 3.2% |
| 111 | 531 | 3.0% |
| 28 | 450 | 2.5% |
| 43 | 406 | 2.3% |
| Other values (152) | 6380 |
| Value | Count | Frequency (%) |
| 0 | 31 | 0.2% |
| 1 | 100 | |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 161 | 298 | 1.7% |
| 160 | 1096 | |
| 159 | 3 | < 0.1% |
| 158 | 1 | < 0.1% |
| 157 | 6 | < 0.1% |
| Distinct | 583 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 9 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.62006028 |
| Minimum | 0 |
|---|---|
| Maximum | 1112 |
| Zeros | 12155 |
| Zeros (%) | 67.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 163 |
| Maximum | 1112 |
| Range | 1112 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 87.71987573 |
|---|---|
| Coefficient of variation (CV) | 3.423874681 |
| Kurtosis | 34.80838146 |
| Mean | 25.62006028 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.347735651 |
| Sum | 459009 |
| Variance | 7694.776598 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12155 | |
| 1 | 849 | 4.7% |
| 2 | 367 | 2.0% |
| 3 | 248 | 1.4% |
| 4 | 230 | 1.3% |
| 5 | 141 | 0.8% |
| 7 | 135 | 0.8% |
| 6 | 120 | 0.7% |
| 8 | 107 | 0.6% |
| 11 | 83 | 0.5% |
| Other values (573) | 3481 | 19.4% |
| Value | Count | Frequency (%) |
| 0 | 12155 | |
| 1 | 849 | 4.7% |
| 2 | 367 | 2.0% |
| 3 | 248 | 1.4% |
| 4 | 230 | 1.3% |
| Value | Count | Frequency (%) |
| 1112 | 1 | |
| 1079 | 1 | |
| 1033 | 1 | |
| 1019 | 1 | |
| 980 | 1 |
has_finished_mifid
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 1 | 10411 | |
| 0 | 7514 |
| Value | Count | Frequency (%) |
| 1 | 10411 | |
| 0 | 7514 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 10411 | |
| 0 | 7514 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 10411 | |
| 0 | 7514 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 10411 | |
| 0 | 7514 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 10411 | |
| 0 | 7514 |
| Distinct | 579 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 7513 |
| Missing (%) | 41.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.13983865 |
| Minimum | 0 |
|---|---|
| Maximum | 1114 |
| Zeros | 2219 |
| Zeros (%) | 12.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 21 |
| 95-th percentile | 264.45 |
| Maximum | 1114 |
| Range | 1114 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 111.2103772 |
|---|---|
| Coefficient of variation (CV) | 2.577904338 |
| Kurtosis | 20.15001096 |
| Mean | 43.13983865 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 4.113110221 |
| Sum | 449172 |
| Variance | 12367.748 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2219 | 12.4% |
| 1 | 2017 | 11.3% |
| 2 | 897 | 5.0% |
| 3 | 566 | 3.2% |
| 4 | 366 | 2.0% |
| 5 | 274 | 1.5% |
| 6 | 206 | 1.1% |
| 7 | 182 | 1.0% |
| 8 | 146 | 0.8% |
| 9 | 101 | 0.6% |
| Other values (569) | 3438 | |
| (Missing) | 7513 |
| Value | Count | Frequency (%) |
| 0 | 2219 | |
| 1 | 2017 | |
| 2 | 897 | |
| 3 | 566 | 3.2% |
| 4 | 366 | 2.0% |
| Value | Count | Frequency (%) |
| 1114 | 1 | |
| 1085 | 1 | |
| 1033 | 1 | |
| 1019 | 1 | |
| 980 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 1 | 5034 | 28.1% |
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 1 | 5034 | 28.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 1 | 5034 | 28.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 1 | 5034 | 28.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 1 | 5034 | 28.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 1 | 5034 | 28.1% |
| Distinct | 539 |
|---|---|
| Distinct (%) | 10.7% |
| Missing | 12891 |
| Missing (%) | 71.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.81466031 |
| Minimum | 0 |
|---|---|
| Maximum | 1105 |
| Zeros | 204 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 18 |
| Q3 | 82 |
| 95-th percentile | 392 |
| Maximum | 1105 |
| Range | 1105 |
| Interquartile range (IQR) | 77 |
Descriptive statistics
| Standard deviation | 142.119085 |
|---|---|
| Coefficient of variation (CV) | 1.780613792 |
| Kurtosis | 9.811300548 |
| Mean | 79.81466031 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 2.911893368 |
| Sum | 401787 |
| Variance | 20197.83431 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 287 | 1.6% |
| 3 | 247 | 1.4% |
| 2 | 241 | 1.3% |
| 0 | 204 | 1.1% |
| 4 | 197 | 1.1% |
| 6 | 184 | 1.0% |
| 5 | 176 | 1.0% |
| 7 | 148 | 0.8% |
| 8 | 118 | 0.7% |
| 9 | 115 | 0.6% |
| Other values (529) | 3117 | 17.4% |
| (Missing) | 12891 |
| Value | Count | Frequency (%) |
| 0 | 204 | |
| 1 | 287 | |
| 2 | 241 | |
| 3 | 247 | |
| 4 | 197 |
| Value | Count | Frequency (%) |
| 1105 | 1 | |
| 1085 | 1 | |
| 1044 | 1 | |
| 1019 | 1 | |
| 983 | 1 |
| Distinct | 670 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.907412657 |
| Minimum | 0 |
|---|---|
| Maximum | 1000 |
| Zeros | 12891 |
| Zeros (%) | 71.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 12 |
| Maximum | 1000 |
| Range | 1000 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 17.78616558 |
|---|---|
| Coefficient of variation (CV) | 6.117523612 |
| Kurtosis | 1163.285926 |
| Mean | 2.907412657 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 27.49295343 |
| Sum | 52115.37188 |
| Variance | 316.3476861 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 2 | 1748 | 9.8% |
| 4 | 875 | 4.9% |
| 8 | 258 | 1.4% |
| 20 | 197 | 1.1% |
| 2.4 | 131 | 0.7% |
| 40 | 123 | 0.7% |
| 12 | 121 | 0.7% |
| 6 | 101 | 0.6% |
| 10 | 68 | 0.4% |
| Other values (660) | 1412 | 7.9% |
| Value | Count | Frequency (%) |
| 0 | 12891 | |
| 0.01116 | 1 | < 0.1% |
| 0.02192 | 1 | < 0.1% |
| 0.028 | 1 | < 0.1% |
| 0.03036 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1000 | 1 | |
| 879.754 | 1 | |
| 739.38 | 1 | |
| 400 | 2 | |
| 399.974 | 1 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.468005579 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1915 |
| Zeros (%) | 10.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.395446839 |
|---|---|
| Coefficient of variation (CV) | 0.9505732536 |
| Kurtosis | 2.009885083 |
| Mean | 1.468005579 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.785047765 |
| Sum | 26314 |
| Variance | 1.947271881 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 12891 | |
| 0 | 1915 | 10.7% |
| 5 | 1683 | 9.4% |
| 3 | 906 | 5.1% |
| 4 | 387 | 2.2% |
| 6 | 114 | 0.6% |
| 2 | 29 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 1915 | 10.7% |
| 1 | 12891 | |
| 2 | 29 | 0.2% |
| 3 | 906 | 5.1% |
| 4 | 387 | 2.2% |
| Value | Count | Frequency (%) |
| 6 | 114 | 0.6% |
| 5 | 1683 | |
| 4 | 387 | 2.2% |
| 3 | 906 | |
| 2 | 29 | 0.2% |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.921562064 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 1543 |
| Zeros (%) | 8.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 10 |
| Q3 | 12 |
| 95-th percentile | 13 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.994764177 |
|---|---|
| Coefficient of variation (CV) | 0.4477651053 |
| Kurtosis | -0.373526453 |
| Mean | 8.921562064 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.7635030379 |
| Sum | 159919 |
| Variance | 15.95814083 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 5823 | |
| 13 | 2772 | |
| 5 | 2107 | 11.8% |
| 6 | 1682 | 9.4% |
| 7 | 1606 | 9.0% |
| 0 | 1543 | 8.6% |
| 8 | 1117 | 6.2% |
| 9 | 670 | 3.7% |
| 10 | 291 | 1.6% |
| 15 | 202 | 1.1% |
| Value | Count | Frequency (%) |
| 0 | 1543 | |
| 5 | 2107 | |
| 6 | 1682 | |
| 7 | 1606 | |
| 8 | 1117 |
| Value | Count | Frequency (%) |
| 15 | 202 | 1.1% |
| 13 | 2772 | |
| 12 | 5823 | |
| 11 | 112 | 0.6% |
| 10 | 291 | 1.6% |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.459804742 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 1543 |
| Zeros (%) | 8.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 8 |
| Q3 | 12 |
| 95-th percentile | 13 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.990576165 |
|---|---|
| Coefficient of variation (CV) | 0.4717101975 |
| Kurtosis | -0.6413946244 |
| Mean | 8.459804742 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.4841732153 |
| Sum | 151642 |
| Variance | 15.92469813 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 3945 | |
| 13 | 3186 | |
| 5 | 2709 | |
| 6 | 2097 | |
| 7 | 1923 | |
| 0 | 1543 | 8.6% |
| 8 | 1224 | 6.8% |
| 9 | 629 | 3.5% |
| 10 | 304 | 1.7% |
| 15 | 197 | 1.1% |
| Value | Count | Frequency (%) |
| 0 | 1543 | |
| 5 | 2709 | |
| 6 | 2097 | |
| 7 | 1923 | |
| 8 | 1224 |
| Value | Count | Frequency (%) |
| 15 | 197 | 1.1% |
| 13 | 3186 | |
| 12 | 3945 | |
| 11 | 168 | 0.9% |
| 10 | 304 | 1.7% |
mifid_qualifications
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 1 | 10837 | |
| 0 | 7088 |
| Value | Count | Frequency (%) |
| 1 | 10837 | |
| 0 | 7088 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 10837 | |
| 0 | 7088 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 10837 | |
| 0 | 7088 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 10837 | |
| 0 | 7088 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 10837 | |
| 0 | 7088 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 1 | 9685 | |
| 0 | 8240 |
| Value | Count | Frequency (%) |
| 1 | 9685 | |
| 0 | 8240 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 9685 | |
| 0 | 8240 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 1 | 9685 | |
| 0 | 8240 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 1 | 9685 | |
| 0 | 8240 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1 | 9685 | |
| 0 | 8240 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.519665272 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 8241 |
| Zeros (%) | 46.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 12 |
| 95-th percentile | 13 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 5.532391874 |
|---|---|
| Coefficient of variation (CV) | 1.002305684 |
| Kurtosis | -1.732952348 |
| Mean | 5.519665272 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.200839344 |
| Sum | 98940 |
| Variance | 30.60735985 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8241 | |
| 12 | 4640 | |
| 13 | 1573 | 8.8% |
| 5 | 1190 | 6.6% |
| 6 | 804 | 4.5% |
| 7 | 638 | 3.6% |
| 8 | 439 | 2.4% |
| 9 | 227 | 1.3% |
| 10 | 83 | 0.5% |
| 15 | 49 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 8241 | |
| 5 | 1190 | 6.6% |
| 6 | 804 | 4.5% |
| 7 | 638 | 3.6% |
| 8 | 439 | 2.4% |
| Value | Count | Frequency (%) |
| 15 | 49 | 0.3% |
| 13 | 1573 | 8.8% |
| 12 | 4640 | |
| 11 | 41 | 0.2% |
| 10 | 83 | 0.5% |
mifid_experience
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 0 | 9889 | |
| 1 | 8036 |
| Value | Count | Frequency (%) |
| 0 | 9889 | |
| 1 | 8036 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9889 | |
| 1 | 8036 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 9889 | |
| 1 | 8036 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 9889 | |
| 1 | 8036 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 9889 | |
| 1 | 8036 |
has_linked_account
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 0 | |
|---|---|
| 1 | 625 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 17300 | |
| 1 | 625 | 3.5% |
| Value | Count | Frequency (%) |
| 0 | 17300 | |
| 1 | 625 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 17300 | |
| 1 | 625 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 17300 | |
| 1 | 625 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 17300 | |
| 1 | 625 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 17300 | |
| 1 | 625 | 3.5% |
| Distinct | 126 |
|---|---|
| Distinct (%) | 20.2% |
| Missing | 17300 |
| Missing (%) | 96.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.8112 |
| Minimum | 0 |
|---|---|
| Maximum | 1033 |
| Zeros | 301 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 14 |
| 95-th percentile | 231 |
| Maximum | 1033 |
| Range | 1033 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 102.5140369 |
|---|---|
| Coefficient of variation (CV) | 2.862625014 |
| Kurtosis | 30.41178242 |
| Mean | 35.8112 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.876431713 |
| Sum | 22382 |
| Variance | 10509.12776 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 301 | 1.7% |
| 1 | 52 | 0.3% |
| 2 | 30 | 0.2% |
| 3 | 28 | 0.2% |
| 4 | 14 | 0.1% |
| 6 | 8 | < 0.1% |
| 10 | 8 | < 0.1% |
| 5 | 6 | < 0.1% |
| 17 | 5 | < 0.1% |
| 8 | 5 | < 0.1% |
| Other values (116) | 168 | 0.9% |
| (Missing) | 17300 |
| Value | Count | Frequency (%) |
| 0 | 301 | |
| 1 | 52 | 0.3% |
| 2 | 30 | 0.2% |
| 3 | 28 | 0.2% |
| 4 | 14 | 0.1% |
| Value | Count | Frequency (%) |
| 1033 | 1 | |
| 838 | 1 | |
| 728 | 1 | |
| 642 | 1 | |
| 620 | 1 |
has_demo_account
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 15221 | |
| 1 | 2704 | 15.1% |
| Value | Count | Frequency (%) |
| 0 | 15221 | |
| 1 | 2704 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15221 | |
| 1 | 2704 | 15.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 15221 | |
| 1 | 2704 | 15.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 15221 | |
| 1 | 2704 | 15.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 15221 | |
| 1 | 2704 | 15.1% |
| Distinct | 166 |
|---|---|
| Distinct (%) | 6.1% |
| Missing | 15221 |
| Missing (%) | 84.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.56065089 |
| Minimum | 0 |
|---|---|
| Maximum | 1019 |
| Zeros | 2056 |
| Zeros (%) | 11.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 50.85 |
| Maximum | 1019 |
| Range | 1019 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 65.02690201 |
|---|---|
| Coefficient of variation (CV) | 4.795264073 |
| Kurtosis | 68.50048565 |
| Mean | 13.56065089 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.468444634 |
| Sum | 36668 |
| Variance | 4228.497985 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2056 | 11.5% |
| 1 | 109 | 0.6% |
| 2 | 53 | 0.3% |
| 4 | 43 | 0.2% |
| 3 | 40 | 0.2% |
| 5 | 31 | 0.2% |
| 7 | 23 | 0.1% |
| 6 | 21 | 0.1% |
| 9 | 19 | 0.1% |
| 11 | 14 | 0.1% |
| Other values (156) | 295 | 1.6% |
| (Missing) | 15221 |
| Value | Count | Frequency (%) |
| 0 | 2056 | |
| 1 | 109 | 0.6% |
| 2 | 53 | 0.3% |
| 3 | 40 | 0.2% |
| 4 | 43 | 0.2% |
| Value | Count | Frequency (%) |
| 1019 | 1 | |
| 792 | 1 | |
| 758 | 1 | |
| 729 | 1 | |
| 671 | 1 |
has_demo_trade
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 15787 | |
| 1 | 2138 | 11.9% |
| Value | Count | Frequency (%) |
| 0 | 15787 | |
| 1 | 2138 | 11.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 15787 | |
| 1 | 2138 | 11.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 15787 | |
| 1 | 2138 | 11.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 15787 | |
| 1 | 2138 | 11.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 15787 | |
| 1 | 2138 | 11.9% |
| Distinct | 224 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 15787 |
| Missing (%) | 88.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.92797007 |
| Minimum | 0 |
|---|---|
| Maximum | 1066 |
| Zeros | 606 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 12.75 |
| 95-th percentile | 159.15 |
| Maximum | 1066 |
| Range | 1066 |
| Interquartile range (IQR) | 12.75 |
Descriptive statistics
| Standard deviation | 83.3932083 |
|---|---|
| Coefficient of variation (CV) | 2.986010373 |
| Kurtosis | 34.34469367 |
| Mean | 27.92797007 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.211646007 |
| Sum | 59710 |
| Variance | 6954.427191 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 606 | 3.4% |
| 1 | 327 | 1.8% |
| 2 | 169 | 0.9% |
| 3 | 115 | 0.6% |
| 4 | 74 | 0.4% |
| 7 | 55 | 0.3% |
| 5 | 52 | 0.3% |
| 6 | 52 | 0.3% |
| 8 | 38 | 0.2% |
| 11 | 32 | 0.2% |
| Other values (214) | 618 | 3.4% |
| (Missing) | 15787 |
| Value | Count | Frequency (%) |
| 0 | 606 | |
| 1 | 327 | |
| 2 | 169 | 0.9% |
| 3 | 115 | 0.6% |
| 4 | 74 | 0.4% |
| Value | Count | Frequency (%) |
| 1066 | 1 | |
| 792 | 1 | |
| 741 | 1 | |
| 729 | 1 | |
| 671 | 1 |
has_mock_account
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 0 | |
|---|---|
| 1 | 77 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 17848 | |
| 1 | 77 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 17848 | |
| 1 | 77 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 17848 | |
| 1 | 77 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 17848 | |
| 1 | 77 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 17848 | |
| 1 | 77 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 17848 | |
| 1 | 77 | 0.4% |
| Distinct | 42 |
|---|---|
| Distinct (%) | 54.5% |
| Missing | 17848 |
| Missing (%) | 99.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.90909091 |
| Minimum | 0 |
|---|---|
| Maximum | 635 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 12 |
| Q3 | 75 |
| 95-th percentile | 336.2 |
| Maximum | 635 |
| Range | 635 |
| Interquartile range (IQR) | 74 |
Descriptive statistics
| Standard deviation | 122.6312596 |
|---|---|
| Coefficient of variation (CV) | 1.705365178 |
| Kurtosis | 6.250862559 |
| Mean | 71.90909091 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 2.404544909 |
| Sum | 5537 |
| Variance | 15038.42584 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 13 | 0.1% |
| 1 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 4 | 5 | < 0.1% |
| 3 | 3 | < 0.1% |
| 49 | 2 | < 0.1% |
| 266 | 2 | < 0.1% |
| 11 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
| 152 | 2 | < 0.1% |
| Other values (32) | 33 | 0.2% |
| (Missing) | 17848 |
| Value | Count | Frequency (%) |
| 0 | 13 | |
| 1 | 8 | |
| 2 | 5 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 635 | 1 | |
| 414 | 1 | |
| 401 | 1 | |
| 393 | 1 | |
| 322 | 1 |
user_flow_name
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 2 | |
|---|---|
| 0 | |
| 1 | 178 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
| Value | Count | Frequency (%) |
| 2 | 13337 | |
| 0 | 4410 | 24.6% |
| 1 | 178 | 1.0% |
| Value | Count | Frequency (%) |
| 2 | 13337 | |
| 0 | 4410 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 13337 | |
| 0 | 4410 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 13337 | |
| 0 | 4410 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2 | 13337 | |
| 0 | 4410 | 24.6% |
| 1 | 178 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 13337 | |
| 0 | 4410 | 24.6% |
| 1 | 178 | 1.0% |
days_until_conversion_or_today
Real number (ℝ≥0)
| Distinct | 1124 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 403.0414505 |
| Minimum | 0 |
|---|---|
| Maximum | 1123 |
| Zeros | 102 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 95 |
| median | 348 |
| Q3 | 682 |
| 95-th percentile | 1012 |
| Maximum | 1123 |
| Range | 1123 |
| Interquartile range (IQR) | 587 |
Descriptive statistics
| Standard deviation | 334.8815129 |
|---|---|
| Coefficient of variation (CV) | 0.8308860353 |
| Kurtosis | -0.9965547722 |
| Mean | 403.0414505 |
| Median Absolute Deviation (MAD) | 275 |
| Skewness | 0.5145764274 |
| Sum | 7224518 |
| Variance | 112145.6277 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 164 | 0.9% |
| 4 | 153 | 0.9% |
| 1 | 150 | 0.8% |
| 6 | 142 | 0.8% |
| 7 | 139 | 0.8% |
| 2 | 132 | 0.7% |
| 8 | 122 | 0.7% |
| 5 | 121 | 0.7% |
| 0 | 102 | 0.6% |
| 9 | 102 | 0.6% |
| Other values (1114) | 16598 |
| Value | Count | Frequency (%) |
| 0 | 102 | |
| 1 | 150 | |
| 2 | 132 | |
| 3 | 164 | |
| 4 | 153 |
| Value | Count | Frequency (%) |
| 1123 | 5 | |
| 1122 | 4 | < 0.1% |
| 1121 | 10 | |
| 1120 | 8 | |
| 1119 | 5 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.2 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 17925 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 13608 | |
| 1 | 4317 | 24.1% |
| Value | Count | Frequency (%) |
| 0 | 13608 | |
| 1 | 4317 | 24.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 13608 | |
| 1 | 4317 | 24.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17925 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 13608 | |
| 1 | 4317 | 24.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17925 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 13608 | |
| 1 | 4317 | 24.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17925 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 13608 | |
| 1 | 4317 | 24.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| user_currency | user_country | start_mifid_days | has_finished_mifid | finish_mifid_days | has_deposit | first_deposit_days | first_deposit_amount | first_deposit_platform | mifid_actual_savings | mifid_next_year_savings | mifid_qualifications | mifid_money_other_brokers | mifid_invested_other_brokers | mifid_experience | has_linked_account | linked_account_days | has_demo_account | demo_account_days | has_demo_trade | demo_trade_days | has_mock_account | mock_account_days | user_flow_name | days_until_conversion_or_today | is_converted | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | EUR | 46 | 0.0 | 1 | 0.0 | 1 | 2.0 | 4.0 | 0 | 13 | 13 | 1 | 1 | 12 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 2 | 1 |
| 1 | USD | 101 | 0.0 | 1 | 1.0 | 1 | 1.0 | 4.0 | 3 | 8 | 5 | 0 | 1 | 7 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 2 | 1 |
| 2 | EUR | 46 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 12 | 13 | 1 | 1 | 12 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 3 | USD | 43 | 0.0 | 1 | 1.0 | 0 | NaN | 0.0 | 1 | 12 | 5 | 1 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 4 | USD | 8 | 1.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 13 | 5 | 1 | 1 | 12 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 5 | EUR | 46 | 0.0 | 1 | 1.0 | 0 | NaN | 0.0 | 1 | 7 | 8 | 1 | 1 | 5 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 6 | EUR | 46 | 7.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 13 | 7 | 0 | 1 | 12 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 7 | USD | 161 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 13 | 13 | 1 | 1 | 12 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 8 | USD | 8 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 12 | 13 | 0 | 1 | 12 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
| 9 | EUR | 46 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 12 | 13 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 8 | 0 |
Last rows
| user_currency | user_country | start_mifid_days | has_finished_mifid | finish_mifid_days | has_deposit | first_deposit_days | first_deposit_amount | first_deposit_platform | mifid_actual_savings | mifid_next_year_savings | mifid_qualifications | mifid_money_other_brokers | mifid_invested_other_brokers | mifid_experience | has_linked_account | linked_account_days | has_demo_account | demo_account_days | has_demo_trade | demo_trade_days | has_mock_account | mock_account_days | user_flow_name | days_until_conversion_or_today | is_converted | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17915 | USD | 30 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1122 | 0 |
| 17916 | USD | 31 | 206.0 | 1 | 229.0 | 1 | 380.0 | 2.4 | 5 | 13 | 5 | 1 | 1 | 13 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1122 | 0 |
| 17917 | USD | 30 | 43.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1122 | 0 |
| 17918 | USD | 160 | 1.0 | 1 | 31.0 | 1 | 393.0 | 2.0 | 2 | 12 | 12 | 1 | 0 | 0 | 1 | 1 | 87.0 | 1 | 84.0 | 1 | 84.0 | 0 | NaN | 2 | 394 | 1 |
| 17919 | EUR | 46 | 0.0 | 1 | 1.0 | 1 | 3.0 | 2.0 | 5 | 13 | 13 | 1 | 0 | 0 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 6 | 1 |
| 17920 | EUR | 46 | 79.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1123 | 0 |
| 17921 | USD | 74 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 5 | 7 | 1 | 0 | 0 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1123 | 0 |
| 17922 | EUR | 46 | 0.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1123 | 0 |
| 17923 | EUR | 0 | 0.0 | 1 | 260.0 | 0 | NaN | 0.0 | 1 | 10 | 6 | 0 | 0 | 0 | 0 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1123 | 0 |
| 17924 | GBP | 74 | 3.0 | 0 | NaN | 0 | NaN | 0.0 | 1 | 7 | 12 | 1 | 0 | 0 | 1 | 0 | NaN | 0 | NaN | 0 | NaN | 0 | NaN | 2 | 1123 | 0 |